CREATE TABLE Cards
(
Id smallint identity(1,1) primary key,
Name nvarchar(20) NOT NULL
);
Go

INSERT INTO Cards(Name)
Values 
('Club Ace'),
('Club 2'),
('Club 3'),
('Club 4'),
('Club 5'),
('Club 6'),
('Club 7'),
('Club 8'),
('Club 9'),
('Club Ten'),
('Club Jack'),
('Club Queen'),
('Club King'),
('Diamond Ace'),
('Diamond 2'),
('Diamond 3'),
('Diamond 4'),
('Diamond 5'),
('Diamond 6'),
('Diamond 7'),
('Diamond 8'),
('Diamond 9'),
('Diamond Ten'),
('Diamond Jack'),
('Diamond Queen'),
('Diamond King'),
('Heart Ace'),
('Heart 2'),
('Heart 3'),
('Heart 4'),
('Heart 5'),
('Heart 6'),
('Heart 7'),
('Heart 8'),
('Heart 9'),
('Heart Ten'),
('Heart Jack'),
('Heart Queen'),
('Heart King'),
('Spade Ace'),
('Spade 2'),
('Spade 3'),
('Spade 4'),
('Spade 5'),
('Spade 6'),
('Spade 7'),
('Spade 8'),
('Spade 9'),
('Spade Ten'),
('Spade Jack'),
('Spade Queen'),
('Spade King')
Go